{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='名爵')]\n",
    "LSG = all1[(all1['brand']=='名爵')]\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CSA7152SDMN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1300</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CSA7152SDMP</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1300</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CSA7152SDMQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1300</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CSA7152SDMQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1300</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CSA7152SDMP</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1300</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CSA7152SDMN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1300</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CSA7152SDAN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1320</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CSA7152SDAQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1320</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>CSA7152SDAP</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1320</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CSA7152SDAQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1320</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>CSA7152SDAN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1320</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>CSA7152SDAP</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1320</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>CSA7153ADMN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1330</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>CSA7153ADMQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1330</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>CSA7153ADMQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1330</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>CSA7153ADMN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1330</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>CSA7153ADMQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1330</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>CSA7153ADMN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1330</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>CSA7153ADMQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1330</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>CSA7153ADMN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1330</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>CSA7153ADMN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1330</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>CSA7153ADMN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1330</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>CSA7153ADAN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1350</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>CSA7153ADAQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1350</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>CSA7153ADAN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1350</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>CSA7153ADAQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1350</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>CSA7153ADAQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1350</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>CSA7153ADAN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1350</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>CSA7153ADAQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1350</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>CSA7153ADAN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1350</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>CSA7186MC</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1483</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653</td>\n",
       "      <td>1827</td>\n",
       "      <td>1480</td>\n",
       "      <td>1796</td>\n",
       "      <td>98</td>\n",
       "      <td>LSJW26H3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653x1827x1480</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>CSA7186MC</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1483</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653</td>\n",
       "      <td>1827</td>\n",
       "      <td>1480</td>\n",
       "      <td>1796</td>\n",
       "      <td>98</td>\n",
       "      <td>LSJW26H3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653x1827x1480</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>CSA7186MC</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1483</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653</td>\n",
       "      <td>1827</td>\n",
       "      <td>1480</td>\n",
       "      <td>1796</td>\n",
       "      <td>98</td>\n",
       "      <td>LSJW26H3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653x1827x1480</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>CSA7185MC</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1486</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653</td>\n",
       "      <td>1827</td>\n",
       "      <td>1480</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LSJW26G3×××××××××,LSJW26G6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653x1827x1480</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>CSA7185MC</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1486</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653</td>\n",
       "      <td>1827</td>\n",
       "      <td>1480</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LSJW26G3×××××××××,LSJW26G6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653x1827x1480</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>CSA7185MC</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1486</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653</td>\n",
       "      <td>1827</td>\n",
       "      <td>1480</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LSJW26G3×××××××××,LSJW26G6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653x1827x1480</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>CSA7185MC</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1486</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653</td>\n",
       "      <td>1827</td>\n",
       "      <td>1480</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LSJW26G3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653x1827x1480</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>CSA7185MC</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1486</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653</td>\n",
       "      <td>1827</td>\n",
       "      <td>1480</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LSJW26G3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2705</td>\n",
       "      <td>4653x1827x1480</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>NJ7181ZLA4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1605</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>NJ7182ZLA4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1605</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>NJ7182ZLA4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1605</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>NJ7181ZLA4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1605</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>NJ7180TF4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1128</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943</td>\n",
       "      <td>1628</td>\n",
       "      <td>1249</td>\n",
       "      <td>1796</td>\n",
       "      <td>100</td>\n",
       "      <td>LNPEF2BH×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943x1628x1249</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵TF</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>NJ7180TF</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1128</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943</td>\n",
       "      <td>1628</td>\n",
       "      <td>1249</td>\n",
       "      <td>1796</td>\n",
       "      <td>100</td>\n",
       "      <td>LNPEF2BH×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943x1628x1249</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵TF</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>NJ7180TF4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1128</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943</td>\n",
       "      <td>1628</td>\n",
       "      <td>1249</td>\n",
       "      <td>1796</td>\n",
       "      <td>100</td>\n",
       "      <td>LNPEF2BH×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943x1628x1249</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵TF</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>NJ7180TF</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1128</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943</td>\n",
       "      <td>1628</td>\n",
       "      <td>1249</td>\n",
       "      <td>1796</td>\n",
       "      <td>100</td>\n",
       "      <td>LNPEF2BH×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943x1628x1249</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵TF</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>NJ7180TF</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1128</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943</td>\n",
       "      <td>1628</td>\n",
       "      <td>1249</td>\n",
       "      <td>1796</td>\n",
       "      <td>100</td>\n",
       "      <td>LNPEF2BH×××××××××</td>\n",
       "      <td>跃进汽车集团公司</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943x1628x1249</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵TF</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>NJ7181ZT4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1500</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>NJ7182ZTM4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1500</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>NJ7182ZTA4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1500</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>NJ7182ZTM4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1500</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>NJ7182ZTA4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1500</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>NJ7181ZT4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1500</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>NJ7250ZL4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1645</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>2497</td>\n",
       "      <td>135</td>\n",
       "      <td>LNPA73BK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>NJ7250ZL3</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1645</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>\"2497</td>\n",
       "      <td>\"140</td>\n",
       "      <td>LNPA73BK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>NJ7250ZL3</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1645</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>2497</td>\n",
       "      <td>140</td>\n",
       "      <td>LNPA73BK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>NJ7250ZL4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1645</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>2497</td>\n",
       "      <td>135</td>\n",
       "      <td>LNPA73BK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>NJ7250ZL</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1645</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>2497</td>\n",
       "      <td>130</td>\n",
       "      <td>LNPA73BK×××××××××</td>\n",
       "      <td>跃进汽车集团公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>CSA7153AC</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1150</td>\n",
       "      <td>2520</td>\n",
       "      <td>3999</td>\n",
       "      <td>1728</td>\n",
       "      <td>1517</td>\n",
       "      <td>1498</td>\n",
       "      <td>80</td>\n",
       "      <td>LSJZ14E3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2520</td>\n",
       "      <td>3999x1728x1517</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>CSA7153AC</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1150</td>\n",
       "      <td>2520</td>\n",
       "      <td>3999</td>\n",
       "      <td>1728</td>\n",
       "      <td>1517</td>\n",
       "      <td>1498</td>\n",
       "      <td>80</td>\n",
       "      <td>LSJZ14E3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2520</td>\n",
       "      <td>3999x1728x1517</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>187 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     notice_type brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0    CSA7152SDMN      名爵        1300      2715       4695      1848   \n",
       "1    CSA7152SDMP      名爵        1300      2715       4695      1848   \n",
       "2    CSA7152SDMQ      名爵        1300      2715       4695      1848   \n",
       "3    CSA7152SDMQ      名爵        1300      2715       4695      1848   \n",
       "4    CSA7152SDMP      名爵        1300      2715       4695      1848   \n",
       "5    CSA7152SDMN      名爵        1300      2715       4695      1848   \n",
       "6    CSA7152SDAN      名爵        1320      2715       4695      1848   \n",
       "7    CSA7152SDAQ      名爵        1320      2715       4695      1848   \n",
       "8    CSA7152SDAP      名爵        1320      2715       4695      1848   \n",
       "9    CSA7152SDAQ      名爵        1320      2715       4695      1848   \n",
       "10   CSA7152SDAN      名爵        1320      2715       4695      1848   \n",
       "11   CSA7152SDAP      名爵        1320      2715       4695      1848   \n",
       "12   CSA7153ADMN      名爵        1330      2650       4612      1804   \n",
       "13   CSA7153ADMQ      名爵        1330      2650       4612      1804   \n",
       "14   CSA7153ADMQ      名爵        1330      2650       4612      1804   \n",
       "15   CSA7153ADMN      名爵        1330      2650       4612      1804   \n",
       "16   CSA7153ADMQ      名爵        1330      2650       4612      1804   \n",
       "17   CSA7153ADMN      名爵        1330      2650       4612      1804   \n",
       "18   CSA7153ADMQ      名爵        1330      2650       4612      1804   \n",
       "19   CSA7153ADMN      名爵        1330      2650       4612      1804   \n",
       "20   CSA7153ADMN      名爵        1330      2650       4612      1804   \n",
       "21   CSA7153ADMN      名爵        1330      2650       4612      1804   \n",
       "22   CSA7153ADAN      名爵        1350      2650       4612      1804   \n",
       "23   CSA7153ADAQ      名爵        1350      2650       4612      1804   \n",
       "24   CSA7153ADAN      名爵        1350      2650       4612      1804   \n",
       "25   CSA7153ADAQ      名爵        1350      2650       4612      1804   \n",
       "26   CSA7153ADAQ      名爵        1350      2650       4612      1804   \n",
       "27   CSA7153ADAN      名爵        1350      2650       4612      1804   \n",
       "28   CSA7153ADAQ      名爵        1350      2650       4612      1804   \n",
       "29   CSA7153ADAN      名爵        1350      2650       4612      1804   \n",
       "..           ...     ...         ...       ...        ...       ...   \n",
       "157    CSA7186MC      名爵        1483      2705       4653      1827   \n",
       "158    CSA7186MC      名爵        1483      2705       4653      1827   \n",
       "159    CSA7186MC      名爵        1483      2705       4653      1827   \n",
       "160    CSA7185MC      名爵        1486      2705       4653      1827   \n",
       "161    CSA7185MC      名爵        1486      2705       4653      1827   \n",
       "162    CSA7185MC      名爵        1486      2705       4653      1827   \n",
       "163    CSA7185MC      名爵        1486      2705       4653      1827   \n",
       "164    CSA7185MC      名爵        1486      2705       4653      1827   \n",
       "165   NJ7181ZLA4      名爵        1605      2949       4949      1761   \n",
       "166   NJ7182ZLA4      名爵        1605      2949       4949      1761   \n",
       "167   NJ7182ZLA4      名爵        1605      2949       4949      1761   \n",
       "168   NJ7181ZLA4      名爵        1605      2949       4949      1761   \n",
       "169    NJ7180TF4      名爵        1128      2375       3943      1628   \n",
       "170     NJ7180TF      名爵        1128      2375       3943      1628   \n",
       "171    NJ7180TF4      名爵        1128      2375       3943      1628   \n",
       "172     NJ7180TF      名爵        1128      2375       3943      1628   \n",
       "173     NJ7180TF      名爵        1128      2375       3943      1628   \n",
       "174    NJ7181ZT4      名爵        1500      2749       4749      1761   \n",
       "175   NJ7182ZTM4      名爵        1500      2749       4749      1761   \n",
       "176   NJ7182ZTA4      名爵        1500      2749       4749      1761   \n",
       "177   NJ7182ZTM4      名爵        1500      2749       4749      1761   \n",
       "178   NJ7182ZTA4      名爵        1500      2749       4749      1761   \n",
       "179    NJ7181ZT4      名爵        1500      2749       4749      1761   \n",
       "180    NJ7250ZL4      名爵        1645      2949       4949      1761   \n",
       "181    NJ7250ZL3      名爵        1645      2949       4949      1761   \n",
       "182    NJ7250ZL3      名爵        1645      2949       4949      1761   \n",
       "183    NJ7250ZL4      名爵        1645      2949       4949      1761   \n",
       "184     NJ7250ZL      名爵        1645      2949       4949      1761   \n",
       "185    CSA7153AC      名爵        1150      2520       3999      1728   \n",
       "186    CSA7153AC      名爵        1150      2520       3999      1728   \n",
       "\n",
       "    car_height Displacement power  \\\n",
       "0         1462         1490   124   \n",
       "1         1462         1490   124   \n",
       "2         1462         1490   124   \n",
       "3         1462         1490   124   \n",
       "4         1462         1490   124   \n",
       "5         1462         1490   124   \n",
       "6         1462         1490   124   \n",
       "7         1462         1490   124   \n",
       "8         1462         1490   124   \n",
       "9         1462         1490   124   \n",
       "10        1462         1490   124   \n",
       "11        1462         1490   124   \n",
       "12        1488         1498    95   \n",
       "13        1488         1498    95   \n",
       "14        1488         1498    95   \n",
       "15        1488         1498    95   \n",
       "16        1488         1498    95   \n",
       "17        1488         1498    95   \n",
       "18        1488         1498    95   \n",
       "19        1488         1498    95   \n",
       "20        1488         1498    95   \n",
       "21        1488         1498    95   \n",
       "22        1488         1498    95   \n",
       "23        1488         1498    95   \n",
       "24        1488         1498    95   \n",
       "25        1488         1498    95   \n",
       "26        1488         1498    95   \n",
       "27        1488         1498    95   \n",
       "28        1488         1498    95   \n",
       "29        1488         1498    95   \n",
       "..         ...          ...   ...   \n",
       "157       1480         1796    98   \n",
       "158       1480         1796    98   \n",
       "159       1480         1796    98   \n",
       "160       1480         1796   118   \n",
       "161       1480         1796   118   \n",
       "162       1480         1796   118   \n",
       "163       1480         1796   118   \n",
       "164       1480         1796   118   \n",
       "165       1421         1796   118   \n",
       "166       1421         1796   118   \n",
       "167       1421         1796   118   \n",
       "168       1421         1796   118   \n",
       "169       1249         1796   100   \n",
       "170       1249         1796   100   \n",
       "171       1249         1796   100   \n",
       "172       1249         1796   100   \n",
       "173       1249         1796   100   \n",
       "174       1421         1796   118   \n",
       "175       1421         1796   118   \n",
       "176       1421         1796   118   \n",
       "177       1421         1796   118   \n",
       "178       1421         1796   118   \n",
       "179       1421         1796   118   \n",
       "180       1421         2497   135   \n",
       "181       1421        \"2497  \"140   \n",
       "182       1421         2497   140   \n",
       "183       1421         2497   135   \n",
       "184       1421         2497   130   \n",
       "185       1517         1498    80   \n",
       "186       1517         1498    80   \n",
       "\n",
       "                                                   vin   car_factory 轴距[mm]  \\\n",
       "0    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "1    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "2    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "3    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "4    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "5    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "6    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "7    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "8    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "9    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "10   LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "11   LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "12   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "13   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "14   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "15   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "16   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "17   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "18   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "19   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "20   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "21   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "22   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "23   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "24   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "25   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "26   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "27   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "28   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "29   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "..                                                 ...           ...    ...   \n",
       "157                                  LSJW26H3×××××××××  上海汽车集团股份有限公司   2705   \n",
       "158                                  LSJW26H3×××××××××  上海汽车集团股份有限公司   2705   \n",
       "159                                  LSJW26H3×××××××××  上海汽车集团股份有限公司   2705   \n",
       "160                LSJW26G3×××××××××,LSJW26G6×××××××××  上海汽车集团股份有限公司   2705   \n",
       "161                LSJW26G3×××××××××,LSJW26G6×××××××××  上海汽车集团股份有限公司   2705   \n",
       "162                LSJW26G3×××××××××,LSJW26G6×××××××××  上海汽车集团股份有限公司   2705   \n",
       "163                                  LSJW26G3×××××××××  上海汽车集团股份有限公司   2705   \n",
       "164                                  LSJW26G3×××××××××  上海汽车集团股份有限公司   2705   \n",
       "165                                  LNPA7PBK×××××××××    南京汽车集团有限公司   2949   \n",
       "166                                  LNPA7PBK×××××××××    南京汽车集团有限公司   2949   \n",
       "167                                  LNPA7PBK×××××××××    南京汽车集团有限公司   2949   \n",
       "168                                  LNPA7PBK×××××××××    南京汽车集团有限公司   2949   \n",
       "169                                  LNPEF2BH×××××××××    南京汽车集团有限公司   2375   \n",
       "170                                  LNPEF2BH×××××××××    南京汽车集团有限公司   2375   \n",
       "171                                  LNPEF2BH×××××××××    南京汽车集团有限公司   2375   \n",
       "172                                  LNPEF2BH×××××××××    南京汽车集团有限公司   2375   \n",
       "173                                  LNPEF2BH×××××××××      跃进汽车集团公司   2375   \n",
       "174                                  LNPA7PBD×××××××××    南京汽车集团有限公司   2749   \n",
       "175                                  LNPA7PBD×××××××××    南京汽车集团有限公司   2749   \n",
       "176                                  LNPA7PBD×××××××××    南京汽车集团有限公司   2749   \n",
       "177                                  LNPA7PBD×××××××××    南京汽车集团有限公司   2749   \n",
       "178                                  LNPA7PBD×××××××××    南京汽车集团有限公司   2749   \n",
       "179                                  LNPA7PBD×××××××××    南京汽车集团有限公司   2749   \n",
       "180                                  LNPA73BK×××××××××    南京汽车集团有限公司   2949   \n",
       "181                                  LNPA73BK×××××××××    南京汽车集团有限公司   2949   \n",
       "182                                  LNPA73BK×××××××××    南京汽车集团有限公司   2949   \n",
       "183                                  LNPA73BK×××××××××    南京汽车集团有限公司   2949   \n",
       "184                                  LNPA73BK×××××××××      跃进汽车集团公司   2949   \n",
       "185                                  LSJZ14E3×××××××××  上海汽车集团股份有限公司   2520   \n",
       "186                                  LSJZ14E3×××××××××  上海汽车集团股份有限公司   2520   \n",
       "\n",
       "          长×宽×高[mm] brand_y style  factory  \n",
       "0    4695x1848x1462      名爵   名爵6        2  \n",
       "1    4695x1848x1462      名爵   名爵6        2  \n",
       "2    4695x1848x1462      名爵   名爵6        2  \n",
       "3    4695x1848x1462      名爵   名爵6        2  \n",
       "4    4695x1848x1462      名爵   名爵6        2  \n",
       "5    4695x1848x1462      名爵   名爵6        2  \n",
       "6    4695x1848x1462      名爵   名爵6        5  \n",
       "7    4695x1848x1462      名爵   名爵6        5  \n",
       "8    4695x1848x1462      名爵   名爵6        5  \n",
       "9    4695x1848x1462      名爵   名爵6        5  \n",
       "10   4695x1848x1462      名爵   名爵6        5  \n",
       "11   4695x1848x1462      名爵   名爵6        5  \n",
       "12   4612x1804x1488      名爵  名爵GT        1  \n",
       "13   4612x1804x1488      名爵  名爵GT        1  \n",
       "14   4612x1804x1488      名爵  名爵GT        1  \n",
       "15   4612x1804x1488      名爵  名爵GT        1  \n",
       "16   4612x1804x1488      名爵  名爵GT        1  \n",
       "17   4612x1804x1488      名爵  名爵GT        1  \n",
       "18   4612x1804x1488      名爵  名爵GT        1  \n",
       "19   4612x1804x1488      名爵  名爵GT        1  \n",
       "20   4612x1804x1488      名爵  名爵GT        1  \n",
       "21   4612x1804x1488      名爵  名爵GT        1  \n",
       "22   4612x1804x1488      名爵  名爵GT        1  \n",
       "23   4612x1804x1488      名爵  名爵GT        1  \n",
       "24   4612x1804x1488      名爵  名爵GT        1  \n",
       "25   4612x1804x1488      名爵  名爵GT        1  \n",
       "26   4612x1804x1488      名爵  名爵GT        1  \n",
       "27   4612x1804x1488      名爵  名爵GT        1  \n",
       "28   4612x1804x1488      名爵  名爵GT        1  \n",
       "29   4612x1804x1488      名爵  名爵GT        1  \n",
       "..              ...     ...   ...      ...  \n",
       "157  4653x1827x1480      名爵   名爵6        2  \n",
       "158  4653x1827x1480      名爵   名爵6        2  \n",
       "159  4653x1827x1480      名爵   名爵6        2  \n",
       "160  4653x1827x1480      名爵   名爵6        2  \n",
       "161  4653x1827x1480      名爵   名爵6        2  \n",
       "162  4653x1827x1480      名爵   名爵6        2  \n",
       "163  4653x1827x1480      名爵   名爵6        2  \n",
       "164  4653x1827x1480      名爵   名爵6        2  \n",
       "165  4949x1761x1421      名爵   名爵7       12  \n",
       "166  4949x1761x1421      名爵   名爵7       12  \n",
       "167  4949x1761x1421      名爵   名爵7       12  \n",
       "168  4949x1761x1421      名爵   名爵7       12  \n",
       "169  3943x1628x1249      名爵  名爵TF        6  \n",
       "170  3943x1628x1249      名爵  名爵TF        6  \n",
       "171  3943x1628x1249      名爵  名爵TF        6  \n",
       "172  3943x1628x1249      名爵  名爵TF        6  \n",
       "173  3943x1628x1249      名爵  名爵TF        6  \n",
       "174  4749x1761x1421      名爵   名爵7       24  \n",
       "175  4749x1761x1421      名爵   名爵7       24  \n",
       "176  4749x1761x1421      名爵   名爵7       24  \n",
       "177  4749x1761x1421      名爵   名爵7       24  \n",
       "178  4749x1761x1421      名爵   名爵7       24  \n",
       "179  4749x1761x1421      名爵   名爵7       24  \n",
       "180  4949x1761x1421      名爵   名爵7       12  \n",
       "181  4949x1761x1421      名爵   名爵7       12  \n",
       "182  4949x1761x1421      名爵   名爵7       12  \n",
       "183  4949x1761x1421      名爵   名爵7       12  \n",
       "184  4949x1761x1421      名爵   名爵7       12  \n",
       "185  3999x1728x1517      名爵   名爵3        2  \n",
       "186  3999x1728x1517      名爵   名爵3        2  \n",
       "\n",
       "[187 rows x 16 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style','curb_weight'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height','curb_weight'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>brand</th>\n",
       "      <th>style</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LSJW54U3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>LSJW54U6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>LSJW54U9×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>LSJZ14U3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>LSJZ14U6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>LSJZ14U9×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>LSJA16U3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>LSJA16U6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>LSJA16U9×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>LSJA16C3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>LSJA16C6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>LSJA16C9×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>LSJA16E3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>LSJA16E6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>LSJA16E9×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1188</th>\n",
       "      <td>LSJA14E3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1189</th>\n",
       "      <td>LSJA14E6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1190</th>\n",
       "      <td>LSJA14E9×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1212</th>\n",
       "      <td>LSJA14U3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1213</th>\n",
       "      <td>LSJA14U6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1214</th>\n",
       "      <td>LSJA14U9×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1444</th>\n",
       "      <td>LSJZ14C3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1445</th>\n",
       "      <td>LSJZ14C6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1446</th>\n",
       "      <td>LSJZ14C9×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1572</th>\n",
       "      <td>LSJZ14E3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1686</th>\n",
       "      <td>LSJW26G3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1687</th>\n",
       "      <td>LSJW26G6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1696</th>\n",
       "      <td>LSJW26H3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1697</th>\n",
       "      <td>LSJW26H6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1708</th>\n",
       "      <td>LSJW26G9×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2166</th>\n",
       "      <td>LSJW24H3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2167</th>\n",
       "      <td>LSJW24H6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2176</th>\n",
       "      <td>LSJW24G3×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2177</th>\n",
       "      <td>LSJW24G9×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2178</th>\n",
       "      <td>LSJW24G6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2696</th>\n",
       "      <td>LSJA24W6×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2697</th>\n",
       "      <td>LSJA24W9×××××××××</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2704</th>\n",
       "      <td>LNPA7PBK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2706</th>\n",
       "      <td>LNPA73BK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2720</th>\n",
       "      <td>LNPA73BK×××××××××</td>\n",
       "      <td>跃进汽车集团公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2722</th>\n",
       "      <td>LNPEF2BH×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵TF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2726</th>\n",
       "      <td>LNPEF2BH×××××××××</td>\n",
       "      <td>跃进汽车集团公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵TF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2727</th>\n",
       "      <td>LNPA7NBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2728</th>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2729</th>\n",
       "      <td>LNPA73BD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2741</th>\n",
       "      <td>LNPA73BD×××××××××</td>\n",
       "      <td>跃进汽车集团公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2742</th>\n",
       "      <td>LNPA7NBD×××××××××</td>\n",
       "      <td>跃进汽车集团公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2743</th>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>跃进汽车集团公司</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    vin   car_factory brand style\n",
       "0     LSJW54U3×××××××××  上海汽车集团股份有限公司    名爵   名爵6\n",
       "1     LSJW54U6×××××××××  上海汽车集团股份有限公司    名爵   名爵6\n",
       "2     LSJW54U9×××××××××  上海汽车集团股份有限公司    名爵   名爵6\n",
       "72    LSJZ14U3×××××××××  上海汽车集团股份有限公司    名爵   名爵3\n",
       "73    LSJZ14U6×××××××××  上海汽车集团股份有限公司    名爵   名爵3\n",
       "74    LSJZ14U9×××××××××  上海汽车集团股份有限公司    名爵   名爵3\n",
       "162   LSJA16U3×××××××××  上海汽车集团股份有限公司    名爵  名爵GT\n",
       "163   LSJA16U6×××××××××  上海汽车集团股份有限公司    名爵  名爵GT\n",
       "164   LSJA16U9×××××××××  上海汽车集团股份有限公司    名爵  名爵GT\n",
       "198   LSJA16C3×××××××××  上海汽车集团股份有限公司    名爵  名爵GT\n",
       "199   LSJA16C6×××××××××  上海汽车集团股份有限公司    名爵  名爵GT\n",
       "200   LSJA16C9×××××××××  上海汽车集团股份有限公司    名爵  名爵GT\n",
       "216   LSJA16E3×××××××××  上海汽车集团股份有限公司    名爵  名爵GT\n",
       "217   LSJA16E6×××××××××  上海汽车集团股份有限公司    名爵  名爵GT\n",
       "218   LSJA16E9×××××××××  上海汽车集团股份有限公司    名爵  名爵GT\n",
       "1188  LSJA14E3×××××××××  上海汽车集团股份有限公司    名爵   名爵5\n",
       "1189  LSJA14E6×××××××××  上海汽车集团股份有限公司    名爵   名爵5\n",
       "1190  LSJA14E9×××××××××  上海汽车集团股份有限公司    名爵   名爵5\n",
       "1212  LSJA14U3×××××××××  上海汽车集团股份有限公司    名爵   名爵5\n",
       "1213  LSJA14U6×××××××××  上海汽车集团股份有限公司    名爵   名爵5\n",
       "1214  LSJA14U9×××××××××  上海汽车集团股份有限公司    名爵   名爵5\n",
       "1444  LSJZ14C3×××××××××  上海汽车集团股份有限公司    名爵   名爵3\n",
       "1445  LSJZ14C6×××××××××  上海汽车集团股份有限公司    名爵   名爵3\n",
       "1446  LSJZ14C9×××××××××  上海汽车集团股份有限公司    名爵   名爵3\n",
       "1572  LSJZ14E3×××××××××  上海汽车集团股份有限公司    名爵   名爵3\n",
       "1686  LSJW26G3×××××××××  上海汽车集团股份有限公司    名爵   名爵6\n",
       "1687  LSJW26G6×××××××××  上海汽车集团股份有限公司    名爵   名爵6\n",
       "1696  LSJW26H3×××××××××  上海汽车集团股份有限公司    名爵   名爵6\n",
       "1697  LSJW26H6×××××××××  上海汽车集团股份有限公司    名爵   名爵6\n",
       "1708  LSJW26G9×××××××××  上海汽车集团股份有限公司    名爵   名爵6\n",
       "2166  LSJW24H3×××××××××  上海汽车集团股份有限公司    名爵   名爵6\n",
       "2167  LSJW24H6×××××××××  上海汽车集团股份有限公司    名爵   名爵6\n",
       "2176  LSJW24G3×××××××××  上海汽车集团股份有限公司    名爵   名爵6\n",
       "2177  LSJW24G9×××××××××  上海汽车集团股份有限公司    名爵   名爵6\n",
       "2178  LSJW24G6×××××××××  上海汽车集团股份有限公司    名爵   名爵6\n",
       "2696  LSJA24W6×××××××××  上海汽车集团股份有限公司    名爵  名爵GS\n",
       "2697  LSJA24W9×××××××××  上海汽车集团股份有限公司    名爵  名爵GS\n",
       "2704  LNPA7PBK×××××××××    南京汽车集团有限公司    名爵   名爵7\n",
       "2706  LNPA73BK×××××××××    南京汽车集团有限公司    名爵   名爵7\n",
       "2720  LNPA73BK×××××××××      跃进汽车集团公司    名爵   名爵7\n",
       "2722  LNPEF2BH×××××××××    南京汽车集团有限公司    名爵  名爵TF\n",
       "2726  LNPEF2BH×××××××××      跃进汽车集团公司    名爵  名爵TF\n",
       "2727  LNPA7NBD×××××××××    南京汽车集团有限公司    名爵   名爵7\n",
       "2728  LNPA7PBD×××××××××    南京汽车集团有限公司    名爵   名爵7\n",
       "2729  LNPA73BD×××××××××    南京汽车集团有限公司    名爵   名爵7\n",
       "2741  LNPA73BD×××××××××      跃进汽车集团公司    名爵   名爵7\n",
       "2742  LNPA7NBD×××××××××      跃进汽车集团公司    名爵   名爵7\n",
       "2743  LNPA7PBD×××××××××      跃进汽车集团公司    名爵   名爵7"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
